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

64 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
vizirate204535(None) 
vizierate2143651vizierate
vizirates2144651vizirates
vibrate122811512vi_brate
vicarate1378602vicarate
vitiate103412952viti_ate
vizierates2243232vizierates
amirate91115953_amirate
aspirate1039943aspirate
biforate1346903biforate
biopirate1374633biopirate
ciliate9514593cili_ate
cirrate92413483ci_rrate
citrate92216793ci_trate
digitate1098683digitate
disrate81418523di_srate
emirate91015833_emirate
figurate1237183figurate
filiate10414233fili_ate
filtrate1148223filtrate
imitate9310873_imitate
ingrate8715113_ingrate
irate55627983___irate
iterate71119103_iterate
levirate1147623levirate
liberate101113383liberate
librate93214233li_brate
literate81216883literate
litigate948303litigate
migrate101314163mi_grate
militate10311673militate
misrate91319143mi_srate
mitigate1148693mitigate
nitrate72017013ni_trate
nizamate1943523nizamate
picrate112014143pi_crate
pirate82322883__pirate
sibilate1049533sibilate
silicate10312623silicate
titivate1146803titivate
titrate72215573ti_trate
vaginate123911083vaginate
valerate11311463valerate
validate1239003validate
variate101316433vari_ate
venerate11312893venerate
vesicate131210053vesicate
vibrated14228383vi_brated
vibrates132210593vi_brates
vibrato12247383vi_brato
vicarage1444433vicarage
vicarates1487613vicarates
vicariate1476353vicariate
vicinage1444003vicinage
vigilante1343633vigilante
vindicate1546353vindicate
violate10311553vi_olate
virgate1138733vi_rgate
vitiated12289223viti_ated
vitiates112311413viti_ates
vittate10409723vi_ttate
vizir17359393vizir___
vizirial2043473vizirial
vizirs18306713vizir__s

Search took 10 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.1701051123.5
2DLD Change Limit146162649.28315745.1
3Display Results64640.0302133.3
 (SQL Overall)178691649.48318843.3
 
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.