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

151 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
outleap929829(None) 
outlead83311101outlead
outleaps10237071outleaps
outleapt10318151outleapt
outbeam1137972outbeam
outbleat1048422outbleat
outeat62824532out_eat
outgleam1153632outgleam
outhear10910602outhear
outkeep1345672outkeep
outlaw9279642outl_aw
outlay92711792outl_ay
outleads9278762outleads
outleaped1246172outleaped
outlearn836432outlearn
outled74020342outle_d
outlet63728682outle_t
outlets73616362outlets
outread82811092outread
outsleep1046012outsleep
outwear1097712outwear
outweep1236672outweep
outyelp1294322outyelp
upleap10106842_upleap
beleap10410283_beleap
burlap1098353burl_ap
butle75023103butle__
butled94818603butle_d
butler84220033butle_r
butlers94518053butlers
butlery12369423butlery
butles84423913butle_s
couteau938833cout_eau
cutlas8313103cutl_as
cutler84718033cutle_r
cutlers94217003cutlers
cutlery12448393cutlery
cutlet84924363cutle_t
cutlets94113653cutlets
dustheap1442323dustheap
gutless82610713gutless
julep14310533ju_le_p
leap66032683___leap
lutea54819073lut_ea_
luteal64411483lut_eal
nucleal946693nucleal
nuclear936233nuclear
nutlet64220563nutle_t
nutlets74111253nutlets
nutmeat947953nutmeat
oatmeal944973oatmeal
olea46532723o__lea_
osteal6312963ost_eal
ostler63312193ostle_r
ostlers72911203ostlers
outbeams1236063outbeams
outbeg938733outbe_g
outbegs1036483outbegs
outbleats1144393outbleats
outbless1037963outbless
outbrag1036993outbrag
outbreak1444773outbreak
outcheat1349413outcheat
outcrop1146773outcrop
outdrag937003outdrag
outdraw1136903outdraw
outdream1144713outdream
outdrop1036193outdrop
outearn7310683out_earn
outeats72215703out_eats
outed65429063out_e_d
outer55633303out_e_r
outers64230173out_ers
outfeast11107503outfeast
outfeel1037543outfeel
outfelt10310603outfelt
outflew1336423outfle_w
outfloat1146243outfloat
outgas7313203out_gas
outgleams1242603outgleams
outgnaw11124353outgnaw
outheard1288543outheard
outhears11810393outhears
outjump1843773outjump
outkeeps1443583outkeeps
outkept1337883outkept
outlaid81110653outlaid
outlain71212613outlain
outland81212343outland
outlast71015443outlast
outlaws10249603outlaws
outlays102610903outlays
outleaping1346203outleaping
outlearns944633outlearns
outlearnt945963outlearnt
outlie62419533outl_ie
outlier72216143outlier
outliers82610673outliers
outlies72421993outlies
outline72321333outline
outlive102513033outlive
outlook1138023outlook
outlove102410243outlove
outman83115033out_man
outplan9249443outplan
outplay12267723outplay
outpray12268083outpray
outran63218893out_ran
outre53922203outre__
outreach1346003outreach
outreads9289003outreads
outroar739513outroar
outsat62920283out_sat
outsaw92610283out_saw
outsay92611873out_say
outsee63121803outse_e
outseen72712333outseen
outsees72616433outsees
outsell7109263outsell
outsert72819513outsert
outset64027453outse_t
outsets73514923outsets
outsleeps1143203outsleeps
outslept1047703outslept
outsoar739493outsoar
outspan938743outspan
outspeak1454583outspeak
outstay1047683outstay
outswam1246613outswam
outswear1144793outswear
outsweep1344913outsweep
outtell797883outtell
outwar91011513out_war
outwears1197263outwears
outweary1485393outweary
outweeps1344013outweeps
outwent10311363outwent
outwept1237933outwept
outyell1095843outyell
outyelps1393073outyelps
overleap13237833overleap
quelea1547303quelea_
queleas1636723queleas
rouleau746823rou_leau
sutler63718393sutle_r
sutlers73116973sutlers
tutelar735373tutelar
unlead73312373_unlead
upheap13105213_upheap
upleaps1185233_upleaps
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 Filter1786911340270.406440125.6
2DLD Change Limit1340271516.67320085.0
3Display Results1511510.0463282.6
 (SQL Overall)1786911517.12525079.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.