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

124 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
outleaps1023707(None) 
outleads9278761outleads
outleap9298291outleap_
outleapt10318151outleapt
outbeams1236062outbeams
outbleats1144392outbleats
outeats72215702out_eats
outgleams1242602outgleams
outhears11810392outhears
outkeeps1443582outkeeps
outlaws10249602outl_aws
outlays102610902outl_ays
outlead83311102outlea_d
outleaped1246172outleaped
outlearn836432outlearn
outlearns944632outlearns
outlets73616362outle_ts
outreads9289002outreads
outsleeps1143202outsleeps
outwears1197262outwears
outweeps1344012outweeps
outyelps1393072outyelps
upleaps1185232_upleaps
beleaps1138053_beleaps
burlaps1156253burl_aps
butlers94518053butle_rs
butles84423913butle__s
cutlas8313103cutl_a_s
cutlass938013cutl_ass
cutlers94217003cutle_rs
cutlets94113653cutle_ts
dustheaps1541873dustheaps
gutless82610713gutle_ss
juleps1535623ju_le_ps
leaps75522933___leaps
nutlets74111253nutle_ts
nutmeats1044463nutmeats
oatmeals1043843oatmeals
ostlers72911203ostle_rs
outbeam1137973outbea_m
outbegs1036483outbe_gs
outbleat1048423outblea_t
outbless1037963outble_ss
outbrags1136693outbrags
outbreaks1544073outbreaks
outcheats1445303outcheats
outclass1037203outclass
outcrops1246853outcrops
outdrags1046583outdrags
outdraws1236233outdraws
outdreams1243553outdreams
outdrops1136543outdrops
outearn7310683out_earn
outearns838403out_earns
outeat62824533out_ea_t
outers64230173out_e_rs
outfeast11107503outfeast
outfeasts12114333outfeasts
outfeels1135063outfeels
outfloats1243573outfloats
outgas7313203out_ga_s
outgleam1153633outglea_m
outgnaws12123893outgnaws
outhear10910603outhea_r
outheard1288543outheard
outjumps1942603outjumps
outkeep1345673outkeep_
outkept1337883outke_pt
outlaid81110653outl_aid
outlain71212613outl_ain
outland81212343outl_and
outlands988563outlands
outlast71015443outl_ast
outlasts8108713outlasts
outlaw9279643outl_a_w
outlay92711793outl_a_y
outleaping1346203outleaping
outlearnt945963outlearnt
outled74020343outle__d
outlet63728683outle__t
outliers82610673outliers
outlies72421993outl_ies
outlines82418093outlines
outlives112511763outlives
outlooks1236793outlooks
outloves11249673outloves
outmans92413283out_mans
outpass939713out_pass
outplans10259533outplans
outplays13246843outplays
outprays13236933outprays
outreach1346003outreach
outread82811093outrea_d
outroars838923outroars
outsays102710403out_says
outsees72616433outse_es
outsells888643outsells
outserts8309803outserts
outsets73514923outse_ts
outsleep1046013outsleep_
outslept1047703outsle_pt
outsoars838853outsoars
outspans1038223outspans
outspeaks1554013outspeaks
outstays1156623outstays
outswears1244303outswears
outsweeps1443193outsweeps
outtells896853outtells
outwars10912793out_wars
outwear1097713outwea_r
outweary1485393outweary
outweep1236673outweep_
outwept1237933outwe_pt
outyells11105303outyells
outyelp1294323outyelp_
overleaps14226783overleaps
queleas1636723quelea_s
rouleaus844983rou_leaus
sutlers73116973sutle_rs
tutelars844993tutelars
unleads8228623_unleads
upheaps1494233_upheaps
upleap10106843_upleap_
upleapt11116863_upleapt

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.423422437.4
2DLD Change Limit1461621247.36019859.0
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.82922824.2
 
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.