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

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

84 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
churl10591388(None) 
churls115411071churls
churn105113101churn
churr104512851churr
curl66035051c_url
hurl76029931_hurl
thurl84912681thurl
ahull84010312ahull
burl64937182_burl
carl65144782c_arl
caul65630002cau_l
ceorl7410912ceorl
char95132152char_
chard116124742chard
chare105231982chare
chark144222712chark
charm126124662charm
charr104821782charr
chars105936632chars
chart105038282chart
chary135023132chary
chert105232102chert
chiel104918972chiel
chill105619872chill
chiral114614412chiral
chirk144516182chirk
chirm125317062chirm
chiro105320342chiro
chirp124717162chirp
chirr105015902chirr
chiru105317152chiru
choral115118492choral
chord115917262chord
chore105126762chore
chub115516412chu_b
chubs125412622chubs
chuck164814872chuck
chufa13489112chufa
chuff164812492chuff
chug105914112chu_g
chugs115511942chugs
chum116318002chu_m
chump145315442chump
chums125015832chums
chunk144812382chunk
church1636482church
churns114910232churns
churro11448352churro
churrs115111512churrs
chute104316462chute
court75532762court
cruel74815902cruel
crura7312582crura
crural8610632crural
cull65929642c_ull
cur56841982c_ur_
curb86732222c_urb
curd77634982c_urd
cure66149122c_ure
curf97538782c_urf
curls74927102c_urls
curly105321232c_urly
curn66731882c_urn
curr65429652c_urr
curs65645542c_urs
curt67051712c_urt
furl77030882_furl
harl75740002_harl
herl75834552_herl
hull75428782_hull
hurls86522712_hurls
hurly115819292_hurly
hurt77142572_hurt
knurl9398912knurl
nurl45327242_nurl
purl65631422_purl
schorl1179802schorl
schul102510412schu_l
shorl84720242shorl
shul75823152shu_l
thirl85416822thirl
thurls9418712thurls
whirl114913822whirl
whorl114612452whorl

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800841.76630464.3
3Display Results84840.0302800.0
 (SQL Overall)178691841.88994595.6
 
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.