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

132 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
resojets153534(None) 
resojet14312821resojet_
resets65427612res__ets
resoles73823652resole_s
resorts74817192reso_rts
besets85718803bes__ets
besots86415453beso__ts
cressets10309103cres_sets
freshets14298673fres_hets
presets94216423pres__ets
presorts105311683preso_rts
projets1639163_projets
pulsojets1841623pulsojets
ramjets1635163r_amjets
reasoners947113reasoners
reboots93512093rebo_ots
rebores95319163rebore_s
recoats92616643reco_ats
recodes102918633recode_s
recounts1038773recounts
recovers133511123recovers
redoes74623753redo_e_s
redoubts11153973redoubts
redouts81411663redo_uts
redoxes15310883redoxe_s
reejects17336083re_ejects
reflets103513153re_flets
reforest1139963reforest
reforests1245533reforests
reglets83512983re_glets
regreets9287853regreets
regrets83212923re_grets
reinjects1844023reinjects
rejects163910693re__jects
relets64025673re__lets
remeets93712413re_meets
remodels1135663remodels
remotes94521613remote_s
remotest103310723remotest
remounts1036373remounts
removers13449223removers
removes124514713remove_s
rennets75212633re_nnets
reobjects2062003reobjects
reopens939373re_opens
reports94916213repo_rts
reposers102911603reposers
reposes94021263repose_s
reposits10310453reposits
repots85621003repo__ts
repowers13288533repowers
reroutes8312223reroutes
resales74724903resale_s
rescores105415693rescore_s
rescuers1037363rescuers
rescues9312753rescue_s
reseats74319583res_eats
resects94115593res_ects
reseeds84012333res_eeds
reseeks11348623res_eeks
resees63827483res__ees
reselects1156413reselects
resents74221223res_ents
reset55051863res__et_
resews94814173res__ews
reshes94124363res_he_s
reshoes102316033reshoe_s
reshoots11228413reshoots
reshowers15145473reshowers
residents1038423residents
residers93311883residers
resides84523283reside_s
resifts10378703res_ifts
resights1246733resights
resiles74026543resile_s
resists74414923res_ists
resites74027793resite_s
resits64725563res__its
resizes164216843resize_s
reslates83619503reslates
resmelts1046143resmelts
resoaks1148973reso_aks
resods74116303reso__ds
resoften1145443resoften
resoftens1243713resoftens
resolders10258013resolders
resole64624183resole__
resoled84119283resole_d
resolute868513resolute
resolutes968193resolutes
resolvents1344343resolvents
resolvers12297833resolvers
resolves113010783resolves
resonants946693resonants
resonate8513513resonate
resonates9412403resonates
resorbs95010523reso_rbs
resort65728613reso_rt_
resorted9313493resorted
resorter8312183resorter
resorters939693resorters
resounds956483resounds
resowed113712253resowe_d
resows93915353reso__ws
respects1247703respects
respites10513243respites
resplits1037723resplits
respots92912763res_pots
restarts8310873restarts
restates83423433restates
resters74130403res_ters
restless82713163restless
restokes125213043restoke_s
restorers95110113restorers
restores85222993restore_s
restress82511773restress
rests54935873res___ts
resubjects2151593resubjects
results739833res_ults
resumers1038083resumers
resumes9313373resume_s
retorts76016513reto_rts
revets94022173re__vets
revokers15366753revokers
revokes144212503revoke_s
revolts1038893revo_lts
revotes104716393revote_s
rewets94617213re__wets
rezones163213943rezone_s
rosets65819953r__osets
russets738163rus_sets
sestets7911473ses_tets

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621328.40617387.8
3Display Results1321320.0462869.6
 (SQL Overall)1786911328.60820758.7
 
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.