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

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

108 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
controllers134478(None) 
controller1245521controller_
comptrollers1851682comptrollers
controlled1345382controlle_d
bankrollers1761953bankrollers
carollers1137703c__arollers
comptroller1751733comptroller_
condolers122710573con_do_lers
confronters1643833confronters
consolers112510923con_so_lers
contrivers1547253contr_ivers
controllership21182203controllership
controlling1445423controlling
controlment1595783controlment
controlments1684443controlments
controls10311393contro_l__s
controversy1952583contro_versy
controvert1547173contro_vert
controverts1654263contro_verts
enrollers976173_en_rollers
logrollers1142223lo_grollers
patrollers1244813_patrollers
strollers937543__strollers
trollers83211213___trollers
bankroller1662364bankroller_
bondholders1852834bondholders
canallers1137214can__allers
cancellers1445364can_cellers
carolers103314174c__aro_lers
caroller1039204c__aroller_
catcallers1443804c_atcallers
centraler1146684centr_aler_
centralizers2354334centralizers
centrioles1245804centriole_s
centromere1453774centro_mere
centromeres1553884centro_meres
coholders1535624co__holders
compellers1645194co_mpellers
concealers1476914con_cealers
concocters1346754con_cocters
condoler113412124con_do_ler_
condoles113015804con_do_le_s
condoners122811514con_do_ners
coneflowers19113154coneflowers
conformers1746554con_formers
confronter1544364confronter_
congealers1365674con_gealers
conjoiners1955404con_joiners
consoler102812614con_so_ler_
consoles103216154con_so_le_s
construers1245874constr__uers
consulters1297214con_sulters
containers1249904cont_ainers
contemners1447074cont_emners
contenders1348624cont_enders
contesters12410184cont_esters
contextless2052484contextless
continuers1247944cont_inuers
contours1039654cont_o__urs
contractors1549164contractors
contrails11410544contrail__s
contraltos1246764contr_altos
contraries12711934contrarie_s
contraveners1753504contraveners
contriver1448344contr_iver_
contrives14311704contr_ive_s
control9310694contro_l___
controllable1653074controllable
controllerships22132024controllerships
controverters1852464controverters
convokers18246104con_vo_kers
convolves1745324con_volve_s
coolers93522494co___o_lers
copyholders2252174copyholders
corollary1443914co__rollary
corollas1039214co__roll_as
coroners104016224co__ro_ners
corulers1039774co__r_ulers
counteroffers2153264counteroffers
counterorders1654474counterorders
crullers1047304c___rullers
decontrolled1661554decontrolle_d
enrollees974324_en_rollees
enroller867184_en_roller_
extollers1663844_ext_ollers
footballers1652234footballers
gondoliers1243694gon_doliers
hostellers1344654host_ellers
knollers12255144_kn__ollers
logroller1042444lo_groller_
nongolfers1443394non_golfers
nonproblems1751654nonproblems
nontalkers1444144nont_alkers
outrolled1037434_outrolle_d
outrolls847824_outroll__s
patroller1145744_patroller_
pontoniers1245324pont_oniers
potboilers1462684po_tboilers
potholders1644344po_tholders
rerollers9207124__rerollers
rollers73117474____rollers
softballers1651684softballers
stroller848174__stroller_
tollers73217464___t_ollers
trillers83613494___trillers
troller73913174___troller_
trolleys11315694___trolleys
uncontrolled1551874uncontrolle_d

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit1488191088.50017508.1
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.96619929.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.