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

176 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
squirter174651(None) 
squinter1747351squinter
squirmer1934361squirmer
squirted1845781squirted
squirters1835061squirters
quarter163211852_quarter
quieter162810332_quieter
quilter16279802_quilter
quirted17369202_quirted
quitter162910752_quitter
skirter11338482s_kirter
spurter94013002spu_rter
squarer163410652squar_er
squatter1735912squatter
squinted1847052squinted
squinters1835512squinters
squintier1844472squintier
squire155912452squir_e_
squired173710052squir_ed
squireen1744382squireen
squires163812832squir_es
squirmed2034162squirmed
squirmers2053102squirmers
squirmier2042842squirmier
squirrel17414522squirrel
squirt153812922squirt__
squirts16348002squirt_s
suiter64121812s_ui_ter
acquirer1944093acquir_er
acquitter2043553acquitter
aquifer1934883aqui_fer
aquiver1934753aqui_ver
blurter9419833blu_rter
bruiter93710633brui_ter
courter94516463cou_rter
curter85320073_cu_rter
equipper2143053equipper
equites162212493equi_tes
esquire16376593esquir_e_
esquired18315073esquir_ed
esquires17266203esquir_es
flirter10318673_flirter
fruiter10309683frui_ter
hurter93915853_hu_rter
inquirer17235173inquir_er
quainter1765903_quainter
quarte154115323_quarte_
quartern17286473_quartern
quarters173110443_quarters
quartes163314933_quartes
quartet162814893_quartet
quartier1737543_quartier
querier16310013_querier
quester161410023_quester
quicker2247023_quicker
quieted17309723_quieted
quieten16258103_quieten
quieters17248733_quieters
quilted17319313_quilted
quilters17228433_quilters
quintar16478603_quintar
quinte153414523_quinte_
quintes164114713_quintes
quintet163914453_quintet
quipper2095813_quipper
quipster1933933_quipster
quire144917123_quir_e_
quired163711943_quir_ed
quires154015733_quir_es
quirked21325423_quirked
quirkier2134163_quirkier
quirt144624233_quirt__
quirts154213553_quirt_s
quite144621463_qui_te_
quitted17339893_quitted
quitters17238523_quitters
quittor16285603_quittor
quiver18278743_qui_ver
quizzer2434393_quizzer
quoter153510093_qu_oter
requirer17156113requir_er
requiter17168643requi_ter
saunter72913453sau_nter
scripter12137773scripter
scutter93512173scu_tter
sequester1844443sequester
sequitur1742973sequi_tur
shifter132911073s_hifter
shirker143711343s_hirker
shirtier1137933s_hirtier
shorter103515493s_horter
shunter103611723shu_nter
shutter103712133shu_tter
sifter94516233s__ifter
sinister838583sinister
sinter63625923s__inter
sister64421583s__ister
sitter63323383s__itter
skirted12388613s_kirted
skirters12337233s_kirters
skitter113810393s_kitter
slitter73615873s_litter
smarter94113133s_marter
smirker13327423s_mirker
smiter83616413s_mi_ter
snifter10349623s_nifter
snorter74412653s_norter
sorter64425083s__orter
sourer63620213sou_r_er
souter64225923sou__ter
spirier93214073s_pirier
spirted103913073s_pirted
spitter94015183s_pitter
splinter10329703splinter
splitter10348443splitter
sporter93616553s_porter
sprinter103810813sprinter
spurner9269653spu_rner
spurrer93710213spu_rrer
spurrier10297683spurrier
spurted103111973spu_rted
spurters103311693spu_rters
sputter94014053spu_tter
squaller1736083squaller
squander1835533squander
square154513353squar_e_
squared173610553squar_ed
squarers17338003squar_ers
squares163714453squar_es
squasher20185773squasher
squatted1835343squatted
squatters1834933squatters
squattier1843713squattier
squawker2443093squawker
squeaker2184883squeaker
squealer17115603squealer
squeezer2643373squeezer
squibbed2283413squibbed
squidded2043713squidded
squiffed2433723squiffed
squiffier2442843squiffier
squilgee1844613squilgee
squinnier1843033squinnier
squint154214793squint__
squintest1845693squintest
squints16339033squint_s
squinty19287053squint_y
squireens1842723squireens
squiring18177553squiring
squirish2045103squirish
squirm17387663squir__m
squirms18376333squir_ms
squirmy21374283squir_my
squirrels18333413squirrels
squirrely21283323squirrely
squirting1934783squirting
squished21186383squished
squishes20198383squishes
squishier2143383squishier
starter73817873s_tarter
stinter73614513s_tinter
stirrer7338223s_tirrer
stricter1039413stricter
stuiver10447083stui_ver
stutter72911463stu_tter
suite54829563s_ui_te_
suited74019423s_ui_ted
suiters73618873s_ui_ters
suites63727403s_ui_tes
suitor63311053s_ui_tor
sumpter1138873s_umpter
surer54833093s_u_r_er
surfer93515883s_u_rfer
surger74320093s_u_rger
swifter13318053s_wifter
unquieter1843003unquieter

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.1731032896.0
2DLD Change Limit1461621767.34319904.9
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.57923577.1
 
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.