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

138 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
aviators1116990(None) 
aviator10229661aviator_
avigators13177071avigators
viators102712011_viators
abators94413072a_bators
ablators1069872ablators
aerators8315612aerators
agitators1046612agitators
animators111210412animators
avatars1036442av_atars
aviates10313062aviat_es
aviations12311552aviations
avigator12236762avigator_
caveators1497252caveators
deviators1358532deviators
evictors13276852evictors
navigators1464822navigators
obviators1444842obviators
radiators1049312radiators
viator93211832_viator_
viatores11257672_viatores
victors123311172_victors
abaters95115193a_baters
abator84512713a_bator_
abdicators1546263abdicators
abettors1056133abettors
ablator939843ablator_
activators1545943activators
actors81016753a__ctors
actuators1146423actuators
adaptors1145253adaptors
adulators1048053adulators
advisors12143903advi_sors
advocators1663913advocators
aerator7314843aerator_
agitator946713agitator_
alastors8311193alastors
aleatory1148813aleatory
alienators1045783alienators
alienors8136733alienors
alleviators14103173alleviators
alligators1145773alligators
amatols938173a_matols
amatory1238613a_matory
animaters11129953animaters
animator101410293animator_
antiatoms1147753antiatoms
anviltops1461663anviltops
aristos7312373aristo_s
aspirators1247003aspirators
assistors945223assistors
auditors947613auditors
avatar937523av_atar_
averters11249503averters
avians93711563avia__ns
aviaries1139773aviaries
aviary12338413avia__ry
aviate9315203aviat__e
aviated11310263aviat_ed
aviatic1239243aviat_ic
aviating12311013aviating
aviation11312743aviation
aviatress1242433aviatress
aviatrix1842133aviatrix
avions94114393avi__ons
avisos95410483avi_so_s
awaiters1146643awaiters
barrators1148393barrators
caveator1387233caveator_
caviars1238623cavia__rs
citators10310233citators
creators102814383creators
curators10311703curators
delators92314823delators
deviator1248313deviator_
deviatory1666443deviatory
diatoms1039073_diatoms
dilators93213173dilators
donators9310383donators
editors839423edi_tors
epilators1149423epilators
equators1737453equators
evertors1138953evertors
evictor12346363evictor_
evocators1446693evocators
expiators1846803expiators
gators74115823__gators
gladiators1243733gladiators
gyrators1245993gyrators
haviors1347383havi__ors
imitators1147003imitators
janitors1536853jani_tors
laminators1247043laminators
laudators1045883laudators
lavatory1445693lav_atory
legators92811023legators
levators11249283levators
levitators1345403levitators
lictors93212583_lictors
locators102910413locators
mandators1247863mandators
mediators1248923mediators
narrators947863narrators
navigator1364883navigator_
negators92411153negators
obviator1344743obviator_
orators7313803_orators
oviraptors1542223oviraptors
palliators1245823palliators
palpators1346793palpators
paviors1237603pavi__ors
quittors17155413quittors
radiator949203radiator_
relators83316113relators
rotators8310183rotators
salivators13135753salivators
saviors1058993savi__ors
senators8312943senators
stators73915553_stators
suitors73012473sui_tors
traitors8310773traitors
urinators947623urinators
valors93413773_v_alors
valuators1286443valuators
vapors113812693_v_apors
varactors1446383varactors
varistors1246513varistors
vavasors14153653vavasors
vectors123212593_vectors
vibrators14237243_vibrators
victor113210673_victor_
victory15326983_victory
vigors102911483_vi_gors
violators1246553_violators
visitors1146433_visitors
visors92912223_vi_sors
vitiators1246913vitiators
vizors18328903_vi_zors

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621389.15615963.5
3Display Results1381380.0632190.5
 (SQL Overall)1786911389.38919032.0
 
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.