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

50 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
cause75225351cause
cabs86739422cabs_
cads76144532cads_
caff125631672ca_ff
caffs135417372caffs
calf96339562ca_lf
calfs104919382calfs
calif104929102calif
cams87047282cams_
cans65050852cans_
canso75019402canso
canst74932212canst
caps87147892caps_
cars67364762cars_
carse74934332carse
casa65630862ca_sa
case65848082ca_se
cash96636282ca_sh
cask105626432ca_sk
cast67159902ca_st
casus76419252casus
cats66356342cats_
caul65630002cau_l
cauld85318442cauld
caulk115315452caulk
cauls75727772cauls
causal81413202causal
caused95117042caused
causer84117782causer
causes88026472causes
causey113513272causey
caws96036112caws_
cays95437672cays_
cayuse11207762cayuse
chuff164812492chuff
clause84311502clause
crus65828482crus_
cruse75726102cruse
crush106815992crush
crust75827662crust
cuff125327992c_uff
cuif96529142c_uif
curf97538782c_urf
cusk105521632c_usk
cusp86021062c_usp
cuss65430612c_uss
gauss65613452gauss
pause75021832pause
taus46342732taus_
vaus75928922vaus_

Search took 3 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.313570897.8
2DLD Change Limit53800501.73331044.4
3Display Results50500.0163125.0
 (SQL Overall)178691502.06286659.1
 
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.