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

105 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
pullout931059(None) 
pullouts1045221pullouts
bullous9311662bullous
bullpout1245782bullpout
fallout10313502fallout
pullet84026332pull_et
pullup1045892pull_up
pulpous1177012pulpous
putout8315112pu_tout
rollout7811942rollout
sellout7313582sellout
allot54933873_allo_t
bailout9414133bailout
ballot84624093ballo_t
bugout9311863bu_gout
bulbous1138293bulbous
bullbat1158553bullbat
bullet84528613bull_et
bullock1537193bullock
bullpouts1343193bullpouts
burgout1049773burgout
burnout9310453burnout
buyout11310103bu_yout
callous93516603callous
clout75330463__clout
cullet84727313cull_et
cutout8315923cu_tout
dugout8310363du_gout
dullest8312633dullest
eelpout947783eelpout
fallouts1137883fallouts
flout86226203__flout
foldout1149533foldout
fullest10313343fullest
fulvous1334543fulvous
gallnut847253gallnut
galloot82814223galloot
gallous82813953gallous
glout65925813__glout
gullet74924833gull_et
hallot95426783hallo_t
holdout11510903holdout
hullo84417453hullo__
hulloa95011183hullo_a
hulloas103911913hulloas
hulloed11369793hulloed
hulloes104113923hulloes
hulloo94511733hullo_o
hulloos104010073hulloos
hullos94916293hullo_s
lout45952143___lout
mullet84126823mull_et
mullock1535713mullock
pallet84232653pall_et
pallium1149013pallium
pallor8313673pallo_r
pallors9314363pallors
parlour937263parlour
parlous9414293parlous
payout11714653p_ayout
pellet83326553pell_et
pigout9314613p_igout
pileous9510523pileous
pillory12247453pillory
pillow113110573pillo_w
pillows122610123pillows
pillowy15316423pillowy
pilot77435063p_ilo_t
pilous84717753p_ilous
plot66141233p__lo_t
pollist9816603pollist
pollock1546843pollock
pollute937383poll_ute
pout65752553p___out
pull64731663pull___
pulled94322193pull_ed
puller83820813pull_er
pullers93618483pullers
pullets94015163pullets
pulley113713403pull_ey
pulleys12399143pulleys
pulling103821073pulling
pullman1135403pullman
pullover13134643pullover
pulls74425053pull__s
pullups1134233pullups
pulpit10310933pu_lpit
pulque1736213pu_lque
pulsant9310563pulsant
pulsojet1754363pulsojet
purloin9107493purloin
purport1159393purport
putlog965553putlo_g
putlogs1065083putlogs
putouts937083pu_touts
rollouts8136733rollouts
rubout8313563ru_bout
runout6414873ru_nout
sellouts837493sellouts
sublot82315523sublo_t
surtout7411673surtout
turnout7410283turnout
umlaut838033_umlaut
villous102810023villous
walkout1447933walkout

Search took 7 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 Limit1340271055.92022639.7
3Display Results1051050.0333181.8
 (SQL Overall)1786911056.35928100.5
 
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.