Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “levanters” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
levanters125499(None) 
levanter1145301levanter_
decanters12229222decanters
leaners73718172le_an_ers
levanted1245322levante_d
levants1037722levant__s
levators11249282leva_tors
recanters112310482recanters
advancers1542983advancers
alexanders1842443alexanders
banters94623113__banters
beaters94925033be_a_ters
betatters1134963betatters
bleaters103412313ble_a_ters
canters94827723__canters
cementers1338303cementers
centers94420593ce__nters
chanters134016723_chanters
cleaners103610533cle_an_ers
cleansers11335063cle_ansers
debaters113511913deba_ters
decanter112510793decanter_
decenters122410373decenters
demanders13247573demanders
derangers1136703derangers
desalters1037673desalters
descanters1345013descanters
dewaters122910713dewa_ters
easters75125683_e_asters
eaters65535943_e_a_ters
elaters74420183_ela_ters
elevateds13122883eleva_teds
elevates111110413eleva_te_s
elevators1246303eleva_tors
enters64425643_e__nters
evaders1136933_eva_ders
evangels1243733_evangels
eveners10109503_even_ers
exacters1736773_exacters
exalters1536653_exalters
feasters11511563fe_asters
gleaners9348073gle_an_ers
granters93614133_granters
heaters104225213he_a_ters
inventers12269523inventers
lamenters1137683lamenters
lancers93616643l__ancers
landers84026213l__anders
lanners73618323l__anners
lantern7310013l__antern
lanterns838303l__anterns
lasters75627693l__asters
lavaliers1254283lavaliers
lavenders1334753lavenders
leachers133712813le_achers
leaders83819603le_a_ders
leaguers935063le_aguers
leakers113415423le_a_kers
leaner64022193le_an_er_
leanness837373le_anness
leapers93716663le_a_pers
learners8398153le_arners
leasers74717843le_a_sers
leathers114215083le_athers
leavers103717783le_a_vers
legatees9258423lega_tees
legates82917673lega_te_s
legators92811023lega_tors
leisters83312823le_isters
lenders84419643le__nders
letters73819853le__tters
levant9314493levant___
levantine1264793levantine
levantines1364223levantines
levanting1345523levanting
levator10298963leva_tor_
levatores12225733leva_tores
levelers11259323lev_elers
levellers12286043levellers
levers94621323lev___ers
leviers103510343lev__iers
linters73822613l__inters
liveners11217923liven_ers
loaners73913623l_oan_ers
locaters102710063loca_ters
meanders1168833me_anders
meaners94415243me_an_ers
negaters9349773nega_ters
oleanders1035573ole_anders
oleasters936733ole_asters
planters102915323_planters
pleaters103613783ple_a_ters
preventers1547393preventers
ranters73323643__ranters
realters83614043re_alters
rebaters103413913reba_ters
recanter101913153recanter_
reenters82915303re_enters
reinters82614773re_inters
relaters83218143rela_ters
remasters11310583remasters
renters74224813re__nters
repenters112511553repenters
revampers1653443revampers
revengers1336413revengers
revenuers1235983revenuers
reverters122710433reverters
revolters12297483revolters
seaters74028933se_a_ters
tenters73921103te__nters
vanners103612843__vanners
vaunters11327743__vaunters
venters103717723__venters
wanters104420093__wanters
weaners104613833we_an_ers

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.1701051123.5
2DLD Change Limit1486411158.95316602.4
3Display Results1151150.0462500.0
 (SQL Overall)1786911159.16919488.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.