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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
outcheat134941(None) 
outcheats1445301outcheats
outbleat1048422outbleat
outcheated1645252outcheated
outeat62824532out__eat
outhear10910602out_hear
butcher143411163butche_r
butchers153710183butchers
butchery18326253butchery
butches144315363butche_s
butthead1454513butthead
cheat105732453___cheat
couthest13312083cout_hest
cutchery18265173cutchery
cutches143216463cutche_s
dutchman1643013dutchman
escheat12410403_escheat
fitchet153113563fitche_t
hatchet153317563hatche_t
hutched16359883hutche_d
hutches153613523hutche_s
latchet123117903latche_t
lunchmeat1642773lunchmeat
mutches143314283mutche_s
nutmeat947953nut_meat
ouched124316933ou_che_d
ouches114322183ou_che_s
outbeam1137973out_beam
outbleats1144393outbleats
outbreak1444773outbreak
outcast91013743outc_ast
outcharm1544733outcharm
outcheating1744873outcheating
outchid1338723outch_id
outchide1447213outchide
outcount1049143outcount
outdream1144713outdream
outdreamt1244203outdreamt
outeats72215703out__eats
outfeast11107503out_feast
outfelt10310603out_felt
outfloat1146243outfloat
outgleam1153633outgleam
outheard1288543out_heard
outhears11810393out_hears
outhit92818473out_h_it
outhunt10311043out_hunt
outkept1337883out_kept
outlead83311103out_lead
outleap9298293out_leap
outleapt10318153out_leapt
outlet63728683out_le_t
outread82811093out_read
outsat62920283out__sat
outscheme1643143outscheme
outscream1343113outscream
outsert72819513out_sert
outset64027453out_se_t
outshoot1149163outshoot
outshot10312103outsh_ot
outshout1149493outshout
outslept1047703outslept
outsmelt10138163outsmelt
outspeak1454583outspeak
outspelt10148403outspelt
outspent101310213outspent
outswear1144793outswear
outswept1346383outswept
outwear1097713out_wear
outwent10311363out_went
outwept1237933out_wept
overheat142413773overheat
postheat13411243post_heat
ratchet124218333ratche_t
recheat12415933_recheat
southeast1246793sout_heast

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.1731032896.0
2DLD Change Limit146162768.01618233.8
3Display Results76760.0302533.3
 (SQL Overall)178691768.21921741.2
 
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.