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 “bilobate” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

75 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
bilobate124703(None) 
bilobated1444971bilobated
biforate1346902biforate
bilabiate1344572bilabiate
globate1057822_globate
kilobase1453872kilobase
kilobyte1742932kilobyte
lobate82915242__lobate
niobate937702ni_obate
trilobate1145432trilobate
allocate10411023allocate
baldpate1345483baldpate
barbate11314543b_arbate
bifoliate1444313bifoliate
bijugate1843513bijugate
bilboa10367843bilboa__
bilboas11438733bilboa_s
billable12179503billable
bilobed1235913bilob_ed
binate8419773bi__nate
biotite9311033bi_otite
birdbath1643173birdbath
bistate9313823bi_state
blate75933783b_l__ate
bloat75229923b_lo_at_
bloated104513433b_lo_ated
bloater94013423b_lo_ater
bloats85215763b_lo_ats
bloviate1384913b_loviate
borate85026153b__orate
bromate11313553b_romate
bullate93415073bul_late
bullbat1158553bullbat_
bullbats1255893bullbats
celibate1259313celibate
chlorate133112693chlorate
ciliate9514603cil_iate
ciliolate1145973ciliolate
cohobate1547013cohobate
colocate12313443colocate
dilatate947773dilatate
dilate73220693dil__ate
diplomate1476353diplomate
dislocate1289133dislocate
filiate10414233fil_iate
filtrate1148223filtrate
globated1265753_globated
iodate7313503_i_odate
isobare946343_isobare
isobath1244613_isobath
isolate7313923_isolate
kilobar1344613kiloba_r
kilobars1444933kilobars
kilobases1543913kilobases
kilobaud1542493kilobaud
kilobit13126883kilobit_
kilobits14124833kilobits
kilobytes1843113kilobytes
kilowatt1544693kilowatt
limbate1139213li_mbate
lobated102610943__lobated
locate83919843__locate
militate10311673militate
mislocate13107713mislocate
niobates1037283ni_obates
niobite937953ni_obite
pileate93815923pil_eate
pilotage1145373pilotage
probate11414483_probate
relocate10713533relocate
silicate10312623silicate
siloxane1543743siloxane
stylobate1442763stylobate
trilobite1144813trilobite
violate10311553vi_olate

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit146162757.44019645.4
3Display Results75750.0302500.0
 (SQL Overall)178691757.89022647.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.