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 “naevoid” 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.

60 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
naevoid119459(None) 
nevoid1098791n_evoid
aneroid8314002aneroid
avoid95516682_a_void
devoid1189362_devoid
haemoid1337202haemoid
naevi867872naev_i_
navaid1037652na_vaid
adenoid959253adenoid
algoid83011473_algoid
ameboid1277233ameboid
android9311513android
aneroids9310203aneroids
anthoid11313313anthoid
aroid65428343_a_roid
avid88325963_a_v_id
avoids104410203_a_voids
cactoid12311033cactoid
catenoid1149113catenoid
ceboid11310653_ceboid
cheloid13310833cheloid
ctenoid1078683ctenoid
devoir1076033_devoir
emeroid101511183emeroid
factoid1338693factoid
gadoid9310463ga_doid
ganoid8314443ga_noid
geoid74215763_ge_oid
glenoid937803glenoid
haloid104317763ha_loid
haploid1339833haploid
hemoid12313513_hemoid
hyenoid1448613hyenoid
keloid11812623_keloid
labroid1038823labroid
laevo849363laevo__
mastoid10711233mastoid
mattoid1079283mattoid
meloid9616003_meloid
myeloid13108123myeloid
naevus934593naev_us
naoi46024633na__oi_
navaids1134803na_vaids
naysaid1145313naysaid
negroid9108893negroid
nereid7312923n_ereid
neuroid81110303neuroid
nevi75116423n_ev_i_
obovoid1342783obovoid
oceloid1037973oceloid
ovoid94811023__ovoid
pavid115717003pa_v_id
racemoid1344813racemoid
salvoed11307063salvoed
sarcoid10310453sarcoid
steroid81314863steroid
tabloid1048263tabloid
theroid11313403theroid
valgoid1255213valgoid
void86220563___void

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 Filter1786911340270.406440125.6
2DLD Change Limit134027606.56020430.9
3Display Results60600.0163750.0
 (SQL Overall)178691606.98225593.1
 
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.